﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using TuyenSinh.DAL;

namespace TuyenSinh.BLL
{
    public  class BDetailEnrolling
    {
        public DataTable GetMajor(int iMajorId, string sName, int iSectionId, int iSchoolId, int isActive, int isDelete)
        {
            return new DADetailEnrolling().GetMajor(iMajorId, sName, iSectionId, iSchoolId, isActive, isDelete).Tables[0];
        }

        public bool InsertDetailEnrolling(int iSchoolId, int iMajorId, int iField1, int iField2, int iNumRegister, int iTarget, double iScore, int iYear, float fNumCompetitor)
        {
            return new DADetailEnrolling().InsertDetailEnrolling(iSchoolId, iMajorId, iField1, iField2,iNumRegister,iTarget,iScore,iYear,fNumCompetitor);
        }

        public DataTable GetSection(int iSectionId, string sName)
        {
            return new DADetailEnrolling().GetSection(iSectionId, sName).Tables[0];
        }

        public DataTable GetDetailEnrolling(int iSchoolId, int iMajorId)
        {
            return new DADetailEnrolling().GetDetailEnrolling(iSchoolId, iMajorId).Tables[0];
        }

        public bool UpdateDetailEnrolling(int iId, int iNumRegister, int iTargets, float iScore, float fCompetitor)
        {
            return new DADetailEnrolling().UpdateDetailEnrolling(iId, iNumRegister, iTargets, iScore, fCompetitor);
        }

        public DataTable GetInforMajorSchool(int iSchoolId, int iMajorId, int iFrom, int iTo)
        {
            return new DADetailEnrolling().GetInforMajorSchool(iSchoolId, iMajorId, iFrom, iTo).Tables[0];
        }

        public DataTable GetMajorMultiSchool(int iMajorId, int iSchoolId, int iYear)
        {
            return new DADetailEnrolling().GetMajorMultiSchool(iMajorId, iSchoolId, iYear).Tables[0];
        }

        public DataTable GetPercentBetweenSchool(int iMajorGroupId, int iRegion, int iYear)
        {
            return new DADetailEnrolling().GetPercentBetweenSchool(iMajorGroupId, iRegion, iYear).Tables[0];
        }

        public DataTable GetPercentFieldBetweenSchool(int iRegion, int iYear)
        {
            return new DADetailEnrolling().GetPercentFieldBetweenSchool(iRegion, iYear).Tables[0];
        }
    }
}
